# -*- coding: utf-8 -*-
# @Time    : 2024/8/29 0:26
# @Author  : Alvin
# @File    : colleges.py


from sqlalchemy import Column, Integer, String, Text, ForeignKey
from sqlalchemy.orm import Relationship

from app.models.base import Base


class College(Base):
    __tablename__ = 'colleges'
    schools = Relationship('School')
    college_id = Column(Integer, primary_key=True)
    college_name = Column(String(100), nullable=False)
    school_id = Column(Integer, ForeignKey('schools.school_id'))
    introduction = Column(Text)
